package com.tianyi.sfzy1.mapper;

import com.tianyi.sfzy1.domain.Announcement;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
* @author Lenovo
* @description 针对表【announcement(公告表)】的数据库操作Mapper
* @createDate 2025-01-02 11:46:53
* @Entity com.tianyi.sfzy1.domain.Announcement
*/
@Mapper
public interface AnnouncementMapper {

    int deleteByPrimaryKey(Long id);

//批量删除公告
    int deleteBatch(@Param("announcementIds") List<Integer> ids);
    int insert(Announcement record);

    int insertSelective(Announcement record);

    Announcement selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(Announcement record);

    int updateByPrimaryKey(Announcement record);
//    咨询师跟公告表联查
List<Announcement> selectAnnouncementWithConsultant(@Param("title") String title, @Param("consultantRealname") String consultantRealname);


}
